FUNCTION

text.repeat

pure function repeat(n: integer): text

Repeat this text n times. SQL compatible.

Examples:

  • 'abc'.repeat(3) returns 'abcabcabc'
  • ''.repeat(3) returns ''
  • 'abc'.repeat(0) returns ''

Parameters

  • n — the number of times to repeat this text

Returns

text equal to this text, except repeated n times

Throws

  • exception — when: - n is negative - n is greater than (2^31)-1 - the resulting text has size greater than (2^31)-1

Since

0.11.0

© 2026 Chromia